# -*- coding: utf-8 -*-
import datetime

#########################################################################
## This scaffolding model makes your app work on Google App Engine too
## File is released under public domain and you can use without limitations
#########################################################################

if not request.env.web2py_runtime_gae:     
  ## if NOT running on Google App Engine use SQLite or other DB
    #db = DAL('mysql://b561_f11_26:b561_f11_26@silo.cs.indiana.edu/b561_f11_26')
    db = DAL('sqlite://storage.sql')
else:
  ## connect to Google BigTable (optional 'google:datastore://namespace')
    db = DAL('google:datastore') 
    ## store sessions and tickets there
    session.connect(request, response, db = db) 
    ## or store session in Memcache, Redis, etc.
    ## from gluon.contrib.memdb import MEMDB
    ## from google.appengine.api.memcache import Client
    ## session.connect(request, response, db = MEMDB(Client()))

## by default give a view/generic.extension to all actions from localhost
## none otherwise. a pattern can be 'controller/function.extension'
response.generic_patterns = ['*'] if request.is_local else []

#########################################################################
## Here is sample code if you need for
## - email capabilities
## - authentication (registration, login, logout, ... )
## - authorization (role based authorization)
## - services (xml, csv, json, xmlrpc, jsonrpc, amf, rss)
## - old style crud actions
## (more options discussed in gluon/tools.py)
#########################################################################

from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
auth = Auth(db, hmac_key=Auth.get_or_create_key()) 
crud, service, plugins = Crud(db), Service(), PluginManager()


##create groups
#auth.add_group('directors','Administrators')
#auth.add_group('dj','Can play songs')
#auth.add_group('staff','Extra permissions')
#auth.add_group('members','Basic members of the website')

_hostname = 'silo.cs.indiana.edu'
_username = 'b561_f11_26'
_password = 'b561_f11_26'
_database = 'b561_f11_26'

"""
db = DAL('mysql://'+_username+':'+_password+'@'+_hostname+'/'+_database)
auth = Auth(db)

auth.settings.table_user = db.define_table('member',
    Field('email', length=128,label=T('Email'), default='', unique=True),
    Field('username', length=128, label=T('User name'), default='', unique=True, 
      requires=IS_NOT_IN_DB(db, 'member.username')
      ),
    Field('password', 'password', readable=False, label=T('Password'),
      requires=CRYPT()
      ),
    Field('gender', length=1, label=T('Gender'), default='',
      requires=(IS_NOT_EMPTY(error_message=auth.messages.is_empty),
        IS_NOT_IN_DB(db, 'member.gender'))
      ),
    Field('address', length=128, label=T('Address'), default='',
      requires=(IS_NOT_EMPTY(error_message=auth.messages.is_empty),
        IS_NOT_IN_DB(db, 'member.address'))
      ),
    Field('phone', length=12, label=T('Phone'), default='',
      requires=(IS_NOT_EMPTY(error_message=auth.messages.is_empty),
        IS_NOT_IN_DB(db, 'member.phone'))
      ),
    Field('birthdate', 'datetime', label=T('Birthdate'), default='',
      requires=(IS_NOT_EMPTY(error_message=auth.messages.is_empty),
        IS_NOT_IN_DB(db, 'member.birthdate'))
      ),
    Field('regdate', 'time', label=T('Regdate'), readable=False, writable=False, default=datetime.datetime.now(),
      requires=(IS_NOT_EMPTY(error_message=auth.messages.is_empty),
        IS_NOT_IN_DB(db, 'member.regdate'))
      ),
    Field('registration_key', length=128, default='', writable=False, readable=False),
    Field('country', 'string', length=15, label=T('Country'),
      requires=IS_NULL_OR(IS_IN_SET(('England')))
      ),
    )
"""

auth.settings.table_user_name = 'member'
auth.settings.registration_requires_verification = False
auth.settings.registration_requires_approval = False
auth.settings.reset_password_requires_verification = True
#auth.define_tables()

#custom_auth_table = db[auth.settings.table_user_name] # get the custom_auth_table
#custom_auth_table.password.requires = [CRYPT()] 
#custom_auth_table.email.requires = [ IS_EMAIL(error_message=auth.messages.invalid_email), IS_NOT_IN_DB(db, custom_auth_table.email)]

#auth.settings.table_user = custom_auth_table # tell auth to use custom_auth_table


## configure email
mail=auth.settings.mailer
mail.settings.server = 'logging' or 'smtp.gmail.com:587'
mail.settings.sender = 'krmckelv@gmail.com'
mail.settings.login = 'username:password'

## configure auth policy
#auth.settings.registration_requires_verification = False
#auth.settings.registration_requires_approval = False
#auth.settings.reset_password_requires_verification = True

## if you need to use OpenID, Facebook, MySpace, Twitter, Linkedin, etc.
## register with janrain.com, write your domain:api_key in private/janrain.key
from gluon.contrib.login_methods.rpx_account import use_janrain
use_janrain(auth,filename='private/janrain.key')

#########################################################################
## Define your tables below (or better in another model file) for example
##
## >>> db.define_table('mytable',Field('myfield','string'))
##
## Fields can be 'string','text','password','integer','double','boolean'
##       'date','time','datetime','blob','upload', 'reference TABLENAME'
## There is an implicit 'id integer autoincrement' field
## Consult manual for more options, validators, etc.
##
## More API examples for controllers:
##
## >>> db.mytable.insert(myfield='value')
## >>> rows=db(db.mytable.myfield=='value').select(db.mytable.ALL)
## >>> for row in rows: print row.id, row.myfield
#########################################################################
